<?php

$sites['T']= array(	'label'	=>	'TtH',
			'surl'	=>	'http://www.tthfanfic.com/story.php?no=$sid&chapter=$chat',
			'upd'	=>	'tthfanficRSS');
$sites['S']= array(	'label'	=>	'SiYE',
			'surl'	=>	'http://www.siye.co.uk/siye/viewstory.php?sid=$sid&textsize=2&chapter=$chat',
			'upd'	=>	'siye');
$sites['I']= array(	'label'	=>	'IKoLY',
			'surl'	=>	'http://www.ikoly.com/fanfic/story.php?no=$sid&chapter=$chat',
			'upd'	=>	'ikoly');
$sites['F']= array(	'label'	=>	'FFnet',
			'surl'	=>	'http://www.fanfiction.net/s/$sid/$chat/',
			'upd'	=>	'ffnetRSS');
			
			
$basesql ="SELECT 	
fic_listing.id,
fic_listing.sitekey,
story_id,
chapter_at,
story_title,
author_name,
fic_authors.linkid,
updated,
status,
chapters,
summary,
favs,
pwp,
inserted 
FROM 
fic_listing 
left join 
fic_authors 
	on fic_listing.author_id=fic_authors.author_id 
	and fic_listing.sitekey=fic_authors.sitekey 
";
define("LISTINGSQL", $basesql);
$resbasesql = $basesql." left join fic_metaverse on fic_listing.id=fic_metaverse.fic_id ";
define("RLISTINGSQL", $resbasesql);
			
?>
